Features
Developer
- Supports most of popular databases. Contrary to majority of database tools, it is not dedicated to only one database. It can work with different data types, functions, procedures, etc. unique for used database server.
- Easy to use. It doesn't need any training. Its object-oriented interface takes you to any database function within a few clicks.
- Shows Tables, Sequences, Views and detailed information for all of them.
- Display all table indexes, constraints, references etc.
- Users can display, update, delete or insert colums, rows, indexes and constraints.
- Integrated SQL editor shows syntax through color coding and allows the user to create professional-looking code. You can run the statement and see the results below. Code competition, text replacing, multilevel undo etc. make this a professional SQL editor.
- Multiwindowed SQL editor. You can add or remove files with sql statements and work with them simultaneously.
- SQL statements History.
- Displays procedures, functions, packages, triggers, java sources etc. Coloured syntax and many functions from SQL editor makes it easy to find the object of our interest.
- Editing and compiling pocedures, functions, triggers, packages, etc.
- Executing and testing pocedures and functions (input and output params values).
- Parametrized SQL queries
- SQL code formater.
- SQL Completion proposal (tables, columns for tables and aliases, procedures, triggers, ...)
- In-grid result data edition (tables window)
- Copy DDL to clipboard (create statements, insert statements, update statements, select statements)
- Simple and useful results filtering and sorting function.
- Transactions
Administrator
- You can view, delete or turncate tables.
- dbDeveloper shows all users existing in the system.
- You can view general information of all database devices installed in the system.
- Shows all system objects (tables, views, sequences, indexes, constraints, etc.)
- In Oracle dbDeveloper can display all sessions and their current status and system locks. Database administrator can kill sessions.
- Execution plan for Oracle, SQLServer and MySQL (DB2 soon).
- Tablespaces, DBLinks, Jobs, Clusters, Directories, Exceptions, etc. (databases special features)
Others
- Multi-document interface techniques lets us work with many open windows in any time. You can watch more than one window at one time. For example, you can edit an SQL statement in one window while looking at table columns in another.
- Export results data to HTML, XML, CSV text files. Also export as 'insert into...' statements.
- Direct or ODBC or BDE (user choice) database connections.
- Interface skins support.